﻿
CREATE PROCEDURE [dbo].[ClearAll] AS
BEGIN
delete from ConfigSettings
	delete from SlowestPages
	delete from SlowestTimerJobs
	delete from TopActiveUsers
	delete from eventlog
	delete from OperatingSystem
	delete from [Database]
	delete from ServiceInstance
	delete from ServiceApplication
	delete from CPU
	delete from Disk
	delete from Server
	delete from User_role
	delete from Role
	delete from Service_RunningJob
	DELETE FROM Web_User
	DELETE FROM [User]
	Delete from [View]
	delete from WebApplication_JobDefinition
	delete from Service_JobDefinition
	DELETE FROM List
	DELETE FROM Web
	DELETE FROM SiteCollection
	DELETE FROM JobDefinition
	DELETE FROM RunningJob
	DELETE FROM WebApplication
	DELETE FROM ApplicationPool
	DELETE FROM Service
	DELETE FROM Farm
	delete from Issue
	delete from [Backup]

	
	
	
	
END